﻿SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO

ALTER TABLE dbo.bht_NemoDataTypes SET (LOCK_ESCALATION = TABLE)

GO

ALTER TABLE dbo.bht_Columns ADD CONSTRAINT
	FK_bht_Columns_bht_NemoDataTypes FOREIGN KEY
	(
	NemoDataType
	) REFERENCES dbo.bht_NemoDataTypes
	(
	DataType
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO

ALTER TABLE dbo.bht_Columns SET (LOCK_ESCALATION = TABLE)

GO

INSERT INTO dbo.bht_NemoDataTypes (DataType, Controller, EditControl)
	VALUES ('location', 'blackhouse.WebNemo.Business.DataTypes.LocationDataType, blackhouse.WebNemo.Business', 'blackhouse.WebNemo.Web.Controls.LocationEditRecordValue, blackhouse.WebNemo.Web')